package com.fowo.api.model.inventory.flow;

import com.alibaba.excel.annotation.ExcelIgnore;
import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.format.DateTimeFormat;
import com.alibaba.excel.annotation.write.style.ContentStyle;
import com.alibaba.excel.enums.poi.HorizontalAlignmentEnum;
import javax.validation.constraints.*;
import lombok.Data;

/** 库存流水 导入导出辅助模型 */
@Data
public class InventoryFlowExcelPo {

  @DateTimeFormat("yyyy年MM月dd日HH:mm:ss")
  @ExcelProperty(value = "操作时间")
  private java.util.Date operationTime;

  @NotBlank(message = "类型不能为空")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "*类型")
  private String type;

  @Size(max = 50, message = "单据号长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "单据号")
  private String num;

  @Size(max = 50, message = "关联单据号长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "关联单据号")
  private String relatedNum;

  @NotNull(message = "品名不能为空")
  @Size(max = 50, message = "品名长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "*品名")
  private String productNameName;

  @ExcelIgnore
  @ExcelProperty(value = "*品名")
  private Long productName;

  @Size(max = 50, message = "SKU长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "SKU")
  private String sku;

  @NotNull(message = "店铺不能为空")
  @Size(max = 50, message = "店铺长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "*店铺")
  private String shopShopName;

  @ExcelIgnore
  @ExcelProperty(value = "*店铺")
  private Long shop;

  @Size(max = 50, message = "FNSKU长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "FNSKU")
  private String fnsku;

  @NotNull(message = "仓库不能为空")
  @Size(max = 50, message = "仓库长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "*仓库")
  private String warehouseName;

  @ExcelIgnore
  @ExcelProperty(value = "*仓库")
  private Long warehouse;

  @ExcelProperty(value = "可用量")
  private Integer availableAmount;

  @ExcelProperty(value = "次品量")
  private Integer defectiveQuantity;

  @ExcelProperty(value = "待检待上架量")
  private Integer inspected;

  @ExcelProperty(value = "可用锁定量")
  private Integer lockAmount;

  @ExcelProperty(value = "次品锁定量")
  private Integer defectiveLockAmount;

  @ExcelProperty(value = "可用在途量")
  private Integer transitAvailable;

  @ExcelProperty(value = "次品在途量")
  private Integer transitDefective;

  @ExcelProperty(value = "采购单价")
  private java.math.BigDecimal purchasePrice;

  @ExcelProperty(value = "单位费用")
  private java.math.BigDecimal unitCosts;

  @Size(max = 50, message = "单位头程长度不能超过20")
  @ExcelProperty(value = "单位头程")
  private java.math.BigDecimal unitheadStroke;

  @ExcelProperty(value = "单位库存成本")
  private java.math.BigDecimal unitInventoryCost;

  @ExcelProperty(value = "货值")
  private java.math.BigDecimal goods;

  @ExcelProperty(value = "费用")
  private java.math.BigDecimal costs;

  @ExcelProperty(value = "头程")
  private java.math.BigDecimal headStroke;

  @ExcelProperty(value = "库存成本")
  private java.math.BigDecimal inventoryCost;

  @Size(max = 50, message = "操作人长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "操作人")
  private String operatorName;

  @ExcelIgnore
  @ExcelProperty(value = "操作人")
  private Long operator;

  @Size(max = 50, message = "备注长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "备注")
  private String remarks;

  @Size(max = 50, message = "更新记录长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "更新记录")
  private String updateRecords;
}
